#!/usr/bin/env python
# coding=utf-8

'''
使用xlwings操作excel的通用类库

app：应用 一个xlwing程序
book: excel程序 工作簿
sheets： 工作表
range：范围

'''

import xlwings as xw
import os

path = os.getcwd()

app = xw.App(visible=False, add_book=False)
# workbook = app.books.add()
workbook = app.books.open(path + r'/text.xlsx')
# sheet = workbook.sheets['sheet1']
# sheet.range('A1').value = '055w'
# workbook.save()
n=workbook.sheets[0]
print(n)
workbook.close()
app.quit()
